CREATE TABLE [dbo].[Account]
(
[AccountId] [int] NOT NULL IDENTITY(1, 1),
[UserName] [nvarchar] (100) COLLATE Cyrillic_General_CI_AS NOT NULL,
[Email] [nvarchar] (100) COLLATE Cyrillic_General_CI_AS NOT NULL,
[Password] [nvarchar] (128) COLLATE Cyrillic_General_CI_AS NOT NULL,
[PasswordSalt] [nvarchar] (128) COLLATE Cyrillic_General_CI_AS NOT NULL,
[LastLoginDate] [datetime] NOT NULL,
[LastLoginIp] [nvarchar] (40) COLLATE Cyrillic_General_CI_AS NULL,
[IsActivated] [bit] NOT NULL,
[IsLockedOut] [bit] NOT NULL,
[LastLockedOutDate] [datetime] NULL,
[LastLockedOutReason] [nvarchar] (256) COLLATE Cyrillic_General_CI_AS NULL,
[NewPasswordKey] [nvarchar] (128) COLLATE Cyrillic_General_CI_AS NULL,
[NewPasswordRequested] [datetime] NULL,
[NewEmail] [nvarchar] (128) COLLATE Cyrillic_General_CI_AS NULL,
[NewEmailKey] [nvarchar] (128) COLLATE Cyrillic_General_CI_AS NULL,
[NewEmailRequested] [datetime] NULL,
[Comments] [nvarchar] (256) COLLATE Cyrillic_General_CI_AS NULL,
[CreatedDate] [datetime] NOT NULL,
[LastModifiedDate] [datetime] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Account] ADD CONSTRAINT [PK_Account] PRIMARY KEY CLUSTERED  ([AccountId]) ON [PRIMARY]
GO
